﻿// =================================================================== 
// 项目说明
//====================================================================
// @Copy Right 2006-2008
// 文件： T_USER.cs
// 项目名称：CRM 
// 创建时间：2012/3/20
// 负责人：
// ===================================================================
using System;
using System.Collections.Generic;
using System.Text;
using DP.Data.OracleClient;
using DP.Data.SqlClient;
using System.Configuration;


namespace CRM.Entity
{
    /// <summary>
    ///T_USER数据实体
    /// </summary>
    [Serializable]
    [OracleTable(TableName = "T_USER", TableOrView = DP.Data.Common.TableType.Table, ConnectionStringKey = "SQLConnString")]
    [SqlTable(TableName = "T_USER", TableOrView = DP.Data.Common.TableType.Table, ConnectionStringKey = "SQLConnString")]
    public class T_USER_Entity
    {
        #region 变量定义
        ///<summary>
        ///用户编号
        ///</summary>
        private long _uSERID;
        ///<summary>
        ///用户姓名
        ///</summary>
        private string _uSERNAME = String.Empty;
        ///<summary>
        ///登录名
        ///</summary>
        private string _lOGINNAME = String.Empty;
        ///<summary>
        ///密码
        ///</summary>
        private string _pASSWORD = String.Empty;
        ///<summary>
        ///性别
        ///</summary>
        private long? _gENDER = 0;
        ///<summary>
        ///部门编号
        ///</summary>
        private long? _dEPARTMENTID = 0;
        ///<summary>
        ///部门名称
        ///</summary>
        private string _dEPARTMENTNAME = String.Empty;
        ///<summary>
        ///角色编号
        ///</summary>
        private long? _rOLEID = 0;
        ///<summary>
        ///角色名称
        ///</summary>
        private string _rOLENAME = String.Empty;
        ///<summary>
        ///登录次数
        ///</summary>
        private long? _lOGINCOUNT = 0;
        ///<summary>
        ///最后登录时间
        ///</summary>
        private DateTime? _lASTLOGINTIME;
        ///<summary>
        ///最后登录IP
        ///</summary>
        private string _lASTLOGINIP = String.Empty;
        ///<summary>
        ///状态
        ///</summary>
        private long? _sTATUS = 0;
        ///<summary>
        ///生日
        ///</summary>
        private DateTime? _bIRTHDATE;
        ///<summary>
        ///座席编号
        ///</summary>
        private string _sEATID = String.Empty;
        ///<summary>
        ///密码最后修改时间
        ///</summary>
        private DateTime? _pWDLASTMODIFYTIME;
        ///<summary>
        ///是否已锁
        ///</summary>
        private long? _lOCKED = 0;
        ///<summary>
        ///密码是否重置
        ///</summary>
        private long? _pWDRESET = 0;
        ///<summary>
        ///手机
        ///</summary>
        private string _mOBILEPHONE = String.Empty;
        ///<summary>
        ///家庭电话
        ///</summary>
        private string _hOMEPHONE = String.Empty;
        ///<summary>
        ///邮件地址
        ///</summary>
        private string _eMAIL = String.Empty;
        ///<summary>
        ///网址
        ///</summary>
        private string _uRL = String.Empty;
        ///<summary>
        ///QQ
        ///</summary>
        private string _qQ = String.Empty;
        ///<summary>
        ///MSN
        ///</summary>
        private string _mSN = String.Empty;
        ///<summary>
        ///分机号
        ///</summary>
        private string _eXT = String.Empty;
        ///<summary>
        ///创建时间
        ///</summary>
        private DateTime? _cREATETIME;
        ///<summary>
        ///创建人编号
        ///</summary>
        private long? _cREATEPEOPLEID = 0;
        ///<summary>
        ///创建人
        ///</summary>
        private string _cREATEPEOPLE = String.Empty;
        ///<summary>
        ///最后修改人编号
        ///</summary>
        private long? _lASTMODIFYPEOPLEID = 0;
        ///<summary>
        ///最后修改人
        ///</summary>
        private string _lASTMODIFYPEOPLE = String.Empty;
        ///<summary>
        ///最后修改时间
        ///</summary>
        private DateTime? _lASTMODIFYTIME;
        ///<summary>
        ///备注
        ///</summary>
        private string _rEMARK = String.Empty;
        ///<summary>
        ///系统管理员
        ///</summary>
        private long? _iSSYSTEMADMIN = 0;
        ///<summary>
        ///事业部编号
        ///</summary>
        private long? _bUSINESSDIVISIONID = 0;
        ///<summary>
        ///事业部名称
        ///</summary>
        private string _bUSINESSDIVISIONNAME = String.Empty;
        ///<summary>
        ///事业部代码
        ///</summary>
        private string _bUSINESSDIVISIONCODE = String.Empty;
        ///<summary>
        ///
        ///</summary>
        private string _uSERTYPE = String.Empty;
        ///<summary>
        ///
        ///</summary>
        private string _dEPARTMENTCODE = String.Empty;
        #endregion

        #region 构造函数
        ///<summary>
        ///
        ///</summary>
        public T_USER_Entity()
        {

        }
        #endregion

        #region 公共属性

        ///<summary>
        ///用户编号
        ///</summary>		
        [OracleColumn(IncrementPrimaryKey = false, PrimaryKey = true, SequenceName = "SQ_T_USER", ColumnDescription = "用户编号", ColumnName = "USERID")]
        [SqlColumn(PrimaryKey = true, IncrementPrimaryKey = true, ColumnDescription = "用户编号", ColumnName = "USERID")]
        public long USERID
        {
            get { return _uSERID; }
            set { _uSERID = value; }

        }

        ///<summary>
        ///用户姓名
        ///</summary>		
        [OracleColumn(ColumnDescription = "用户姓名", ColumnName = "USERNAME")]
        [SqlColumn(ColumnDescription = "用户姓名", ColumnName = "USERNAME")]
        public string USERNAME
        {
            get { return _uSERNAME; }
            set
            {
                _uSERNAME = value;
            }

        }

        ///<summary>
        ///登录名
        ///</summary>		
        [OracleColumn(ColumnDescription = "登录名", ColumnName = "LOGINNAME")]
        [SqlColumn(ColumnDescription = "登录名", ColumnName = "LOGINNAME")]
        public string LOGINNAME
        {
            get { return _lOGINNAME; }
            set
            {
                _lOGINNAME = value;
            }

        }

        ///<summary>
        ///密码
        ///</summary>		
        [OracleColumn(ColumnDescription = "密码", ColumnName = "PASSWORD")]
        [SqlColumn(ColumnDescription = "密码", ColumnName = "PASSWORD")]
        public string PASSWORD
        {
            get { return _pASSWORD; }
            set
            {
                _pASSWORD = value;
            }

        }

        ///<summary>
        ///性别
        ///</summary>		
        [OracleColumn(ColumnDescription = "性别", ColumnName = "GENDER")]
        [SqlColumn(ColumnDescription = "性别", ColumnName = "GENDER")]
        public long? GENDER
        {
            get { return _gENDER; }
            set { _gENDER = value; }

        }

        ///<summary>
        ///部门编号
        ///</summary>		
        [OracleColumn(ColumnDescription = "部门编号", ColumnName = "DEPARTMENTID")]
        [SqlColumn(ColumnDescription = "部门编号", ColumnName = "DEPARTMENTID")]
        public long? DEPARTMENTID
        {
            get { return _dEPARTMENTID; }
            set { _dEPARTMENTID = value; }

        }

        ///<summary>
        ///部门名称
        ///</summary>		
        [OracleColumn(ColumnDescription = "部门名称", ColumnName = "DEPARTMENTNAME")]
        [SqlColumn(ColumnDescription = "部门名称", ColumnName = "DEPARTMENTNAME")]
        public string DEPARTMENTNAME
        {
            get { return _dEPARTMENTNAME; }
            set
            {
                _dEPARTMENTNAME = value;
            }

        }

        ///<summary>
        ///角色编号
        ///</summary>		
        [OracleColumn(ColumnDescription = "角色编号", ColumnName = "ROLEID")]
        [SqlColumn(ColumnDescription = "角色编号", ColumnName = "ROLEID")]
        public long? ROLEID
        {
            get { return _rOLEID; }
            set { _rOLEID = value; }

        }

        ///<summary>
        ///角色名称
        ///</summary>		
        [OracleColumn(ColumnDescription = "角色名称", ColumnName = "ROLENAME")]
        [SqlColumn(ColumnDescription = "角色名称", ColumnName = "ROLENAME")]
        public string ROLENAME
        {
            get { return _rOLENAME; }
            set
            {
                _rOLENAME = value;
            }

        }

        ///<summary>
        ///登录次数
        ///</summary>		
        [OracleColumn(ColumnDescription = "登录次数", ColumnName = "LOGINCOUNT")]
        [SqlColumn(ColumnDescription = "登录次数", ColumnName = "LOGINCOUNT")]
        public long? LOGINCOUNT
        {
            get { return _lOGINCOUNT; }
            set { _lOGINCOUNT = value; }

        }

        ///<summary>
        ///最后登录时间
        ///</summary>		
        [OracleColumn(ColumnDescription = "最后登录时间", ColumnName = "LASTLOGINTIME")]
        [SqlColumn(ColumnDescription = "最后登录时间", ColumnName = "LASTLOGINTIME")]
        public DateTime? LASTLOGINTIME
        {
            get { return _lASTLOGINTIME; }
            set { _lASTLOGINTIME = value; }

        }

        ///<summary>
        ///最后登录IP
        ///</summary>		
        [OracleColumn(ColumnDescription = "最后登录IP", ColumnName = "LASTLOGINIP")]
        [SqlColumn(ColumnDescription = "最后登录IP", ColumnName = "LASTLOGINIP")]
        public string LASTLOGINIP
        {
            get { return _lASTLOGINIP; }
            set
            {
                _lASTLOGINIP = value;
            }

        }

        ///<summary>
        ///状态
        ///</summary>		
        [OracleColumn(ColumnDescription = "状态", ColumnName = "STATUS")]
        [SqlColumn(ColumnDescription = "状态", ColumnName = "STATUS")]
        public long? STATUS
        {
            get { return _sTATUS; }
            set { _sTATUS = value; }

        }

        ///<summary>
        ///生日
        ///</summary>		
        [OracleColumn(ColumnDescription = "生日", ColumnName = "BIRTHDATE")]
        [SqlColumn(ColumnDescription = "生日", ColumnName = "BIRTHDATE")]
        public DateTime? BIRTHDATE
        {
            get { return _bIRTHDATE; }
            set { _bIRTHDATE = value; }

        }

        ///<summary>
        ///座席编号
        ///</summary>		
        [OracleColumn(ColumnDescription = "座席编号", ColumnName = "SEATID")]
        [SqlColumn(ColumnDescription = "座席编号", ColumnName = "SEATID")]
        public string SEATID
        {
            get { return _sEATID; }
            set
            {
                _sEATID = value;
            }

        }

        ///<summary>
        ///密码最后修改时间
        ///</summary>		
        [OracleColumn(ColumnDescription = "密码最后修改时间", ColumnName = "PWDLASTMODIFYTIME")]
        [SqlColumn(ColumnDescription = "密码最后修改时间", ColumnName = "PWDLASTMODIFYTIME")]
        public DateTime? PWDLASTMODIFYTIME
        {
            get { return _pWDLASTMODIFYTIME; }
            set { _pWDLASTMODIFYTIME = value; }

        }

        ///<summary>
        ///是否已锁
        ///</summary>		
        [OracleColumn(ColumnDescription = "是否已锁", ColumnName = "LOCKED")]
        [SqlColumn(ColumnDescription = "是否已锁", ColumnName = "LOCKED")]
        public long? LOCKED
        {
            get { return _lOCKED; }
            set { _lOCKED = value; }

        }

        ///<summary>
        ///密码是否重置
        ///</summary>		
        [OracleColumn(ColumnDescription = "密码是否重置", ColumnName = "PWDRESET")]
        [SqlColumn(ColumnDescription = "密码是否重置", ColumnName = "PWDRESET")]
        public long? PWDRESET
        {
            get { return _pWDRESET; }
            set { _pWDRESET = value; }

        }

        ///<summary>
        ///手机
        ///</summary>		
        [OracleColumn(ColumnDescription = "手机", ColumnName = "MOBILEPHONE")]
        [SqlColumn(ColumnDescription = "手机", ColumnName = "MOBILEPHONE")]
        public string MOBILEPHONE
        {
            get { return _mOBILEPHONE; }
            set
            {
                _mOBILEPHONE = value;
            }

        }

        ///<summary>
        ///家庭电话
        ///</summary>		
        [OracleColumn(ColumnDescription = "家庭电话", ColumnName = "HOMEPHONE")]
        [SqlColumn(ColumnDescription = "家庭电话", ColumnName = "HOMEPHONE")]
        public string HOMEPHONE
        {
            get { return _hOMEPHONE; }
            set
            {
                _hOMEPHONE = value;
            }

        }

        ///<summary>
        ///邮件地址
        ///</summary>		
        [OracleColumn(ColumnDescription = "邮件地址", ColumnName = "EMAIL")]
        [SqlColumn(ColumnDescription = "邮件地址", ColumnName = "EMAIL")]
        public string EMAIL
        {
            get { return _eMAIL; }
            set
            {
                _eMAIL = value;
            }

        }

        ///<summary>
        ///网址
        ///</summary>		
        [OracleColumn(ColumnDescription = "网址", ColumnName = "URL")]
        [SqlColumn(ColumnDescription = "网址", ColumnName = "URL")]
        public string URL
        {
            get { return _uRL; }
            set
            {
                _uRL = value;
            }

        }

        ///<summary>
        ///QQ
        ///</summary>		
        [OracleColumn(ColumnDescription = "QQ", ColumnName = "QQ")]
        [SqlColumn(ColumnDescription = "QQ", ColumnName = "QQ")]
        public string QQ
        {
            get { return _qQ; }
            set
            {
                _qQ = value;
            }

        }

        ///<summary>
        ///MSN
        ///</summary>		
        [OracleColumn(ColumnDescription = "MSN", ColumnName = "MSN")]
        [SqlColumn(ColumnDescription = "MSN", ColumnName = "MSN")]
        public string MSN
        {
            get { return _mSN; }
            set
            {
                _mSN = value;
            }

        }

        ///<summary>
        ///分机号
        ///</summary>		
        [OracleColumn(ColumnDescription = "分机号", ColumnName = "EXT")]
        [SqlColumn(ColumnDescription = "分机号", ColumnName = "EXT")]
        public string EXT
        {
            get { return _eXT; }
            set
            {
                _eXT = value;
            }

        }

        ///<summary>
        ///创建时间
        ///</summary>		
        [OracleColumn(ColumnDescription = "创建时间", ColumnName = "CREATETIME")]
        [SqlColumn(ColumnDescription = "创建时间", ColumnName = "CREATETIME")]
        public DateTime? CREATETIME
        {
            get { return _cREATETIME; }
            set { _cREATETIME = value; }

        }

        ///<summary>
        ///创建人编号
        ///</summary>		
        [OracleColumn(ColumnDescription = "创建人编号", ColumnName = "CREATEPEOPLEID")]
        [SqlColumn(ColumnDescription = "创建人编号", ColumnName = "CREATEPEOPLEID")]
        public long? CREATEPEOPLEID
        {
            get { return _cREATEPEOPLEID; }
            set { _cREATEPEOPLEID = value; }

        }

        ///<summary>
        ///创建人
        ///</summary>		
        [OracleColumn(ColumnDescription = "创建人", ColumnName = "CREATEPEOPLE")]
        [SqlColumn(ColumnDescription = "创建人", ColumnName = "CREATEPEOPLE")]
        public string CREATEPEOPLE
        {
            get { return _cREATEPEOPLE; }
            set
            {
                _cREATEPEOPLE = value;
            }

        }

        ///<summary>
        ///最后修改人编号
        ///</summary>		
        [OracleColumn(ColumnDescription = "最后修改人编号", ColumnName = "LASTMODIFYPEOPLEID")]
        [SqlColumn(ColumnDescription = "最后修改人编号", ColumnName = "LASTMODIFYPEOPLEID")]
        public long? LASTMODIFYPEOPLEID
        {
            get { return _lASTMODIFYPEOPLEID; }
            set { _lASTMODIFYPEOPLEID = value; }

        }

        ///<summary>
        ///最后修改人
        ///</summary>		
        [OracleColumn(ColumnDescription = "最后修改人", ColumnName = "LASTMODIFYPEOPLE")]
        [SqlColumn(ColumnDescription = "最后修改人", ColumnName = "LASTMODIFYPEOPLE")]
        public string LASTMODIFYPEOPLE
        {
            get { return _lASTMODIFYPEOPLE; }
            set
            {
                _lASTMODIFYPEOPLE = value;
            }

        }

        ///<summary>
        ///最后修改时间
        ///</summary>		
        [OracleColumn(ColumnDescription = "最后修改时间", ColumnName = "LASTMODIFYTIME")]
        [SqlColumn(ColumnDescription = "最后修改时间", ColumnName = "LASTMODIFYTIME")]
        public DateTime? LASTMODIFYTIME
        {
            get { return _lASTMODIFYTIME; }
            set { _lASTMODIFYTIME = value; }

        }

        ///<summary>
        ///备注
        ///</summary>		
        [OracleColumn(ColumnDescription = "备注", ColumnName = "REMARK")]
        [SqlColumn(ColumnDescription = "备注", ColumnName = "REMARK")]
        public string REMARK
        {
            get { return _rEMARK; }
            set
            {
                _rEMARK = value;
            }

        }

        ///<summary>
        ///系统管理员
        ///</summary>		
        [OracleColumn(ColumnDescription = "系统管理员", ColumnName = "ISSYSTEMADMIN")]
        [SqlColumn(ColumnDescription = "系统管理员", ColumnName = "ISSYSTEMADMIN")]
        public long? ISSYSTEMADMIN
        {
            get { return _iSSYSTEMADMIN; }
            set { _iSSYSTEMADMIN = value; }

        }

        ///<summary>
        ///事业部编号
        ///</summary>		
        [OracleColumn(ColumnDescription = "事业部编号", ColumnName = "BUSINESSDIVISIONID")]
        [SqlColumn(ColumnDescription = "事业部编号", ColumnName = "BUSINESSDIVISIONID")]
        public long? BUSINESSDIVISIONID
        {
            get { return _bUSINESSDIVISIONID; }
            set { _bUSINESSDIVISIONID = value; }

        }

        ///<summary>
        ///事业部名称
        ///</summary>		
        [OracleColumn(ColumnDescription = "事业部名称", ColumnName = "BUSINESSDIVISIONNAME")]
        [SqlColumn(ColumnDescription = "事业部名称", ColumnName = "BUSINESSDIVISIONNAME")]
        public string BUSINESSDIVISIONNAME
        {
            get { return _bUSINESSDIVISIONNAME; }
            set
            {
                _bUSINESSDIVISIONNAME = value;
            }

        }

        ///<summary>
        ///事业部代码
        ///</summary>		
        [OracleColumn(ColumnDescription = "事业部代码", ColumnName = "BUSINESSDIVISIONCODE")]
        [SqlColumn(ColumnDescription = "事业部代码", ColumnName = "BUSINESSDIVISIONCODE")]
        public string BUSINESSDIVISIONCODE
        {
            get { return _bUSINESSDIVISIONCODE; }
            set
            {
                _bUSINESSDIVISIONCODE = value;
            }

        }

        ///<summary>
        ///
        ///</summary>		
        [OracleColumn(ColumnDescription = "", ColumnName = "USERTYPE")]
        [SqlColumn(ColumnDescription = "", ColumnName = "USERTYPE")]
        public string USERTYPE
        {
            get { return _uSERTYPE; }
            set
            {
                _uSERTYPE = value;
            }

        }

        ///<summary>
        ///
        ///</summary>		
        [OracleColumn(ColumnDescription = "", ColumnName = "DEPARTMENTCODE")]
        [SqlColumn(ColumnDescription = "", ColumnName = "DEPARTMENTCODE")]
        public string DEPARTMENTCODE
        {
            get { return _dEPARTMENTCODE; }
            set
            {
                _dEPARTMENTCODE = value;
            }

        }


        #endregion

    }
}
